﻿/*
Post-Deployment Script Template							
--------------------------------------------------------------------------------------
 This file contains SQL statements that will be appended to the build script.		
 Use SQLCMD syntax to include a file in the post-deployment script.			
 Example:      :r .\myfile.sql								
 Use SQLCMD syntax to reference a variable in the post-deployment script.		
 Example:      :setvar TableName MyTable							
               SELECT * FROM [$(TableName)]					
--------------------------------------------------------------------------------------
*/

INSERT INTO [BPMEngine].[dbo].[Participants]
           ([ParticipantId]
		   ,[LastName]
		   ,[FirstName]
           ,[Email])
     VALUES
     (
           1,
           'Khaymov', 
           'Dmitry',
		   'dmitry.khaymov@gmail.com'
      );

INSERT INTO [BPMEngine].[dbo].[Participants]
           ([ParticipantId]
		   ,[LastName]
		   ,[FirstName]
           ,[Email])
     VALUES
     (
           2,
           'Gumnik', 
           'Aharon',
		   'agumnik@gmail.com'
      );

INSERT INTO [BPMEngine].[dbo].[Participants]
           ([ParticipantId]
		   ,[LastName]
		   ,[FirstName]
           ,[Email])
     VALUES
     (
           3,
           'Mizrachi', 
           'Alex',
		   'alex.mizrachi@gmail.com'
      );
GO
